#! /usr/bin/perl -w my $in=""; my @row=(); my %family=(); my %sp=(); my @newrow=(); while ($in=){ chomp($in); @row=split(/\t/,$in); $family{$row[0]}=$row[1]; $sp{$row[0]}=$row[2]; } while (){ chomp($_); @newrow=split(/\t/,$_); print "$_\t$family{$newrow[4]}\t$sp{$newrow[4]}\n"; } __END__ SPP00000001_1.0 Iodothyronine deiodinase 1 (DI1) Homo sapiens SPP00000002_1.0 Iodothyronine deiodinase 2 (DI2) Homo sapiens SPP00000003_1.0 Iodothyronine deiodinase 3 (DI3) Homo sapiens SPP00000004_1.0 Glutathione peroxidase 1 (GPx1) Homo sapiens SPP00000005_1.0 Glutathione peroxidase 2 (GPx2) Homo sapiens SPP00000006_1.0 Glutathione peroxidase 3 (GPx3) Homo sapiens SPP00000007_1.0 Glutathione peroxidase 4 (GPx4) Homo sapiens SPP00000008_1.0 Glutathione peroxidase 5 (GPx5) Homo sapiens SPP00000009_1.0 Glutathione peroxidase 6 (GPx6) Homo sapiens SPP00000010_1.0 Glutathione peroxidase 7 (GPx7) Homo sapiens SPP00000011_1.0 Glutathione peroxidase 8 (GPx8) Homo sapiens SPP00000012_1.0 Methionine sulfoxide reductase A (MsrA) Homo sapiens SPP00000013_1.0 Selenoprotein 15 (Sel15) Homo sapiens SPP00000014_1.0 Selenoprotein H (SelH) Homo sapiens SPP00000015_1.0 Selenoprotein I (SelI) Homo sapiens SPP00000016_1.0 Selenoprotein K (SelK) Homo sapiens SPP00000017_1.0 Selenoprotein M (SelM) Homo sapiens SPP00000018_1.0 Selenoprotein N (SelN) Homo sapiens SPP00000019_1.0 Selenoprotein O (SelO) Homo sapiens SPP00000020_1.0 Selenoprotein P (SelP) Homo sapiens SPP00000021_1.0 Methionine-R-sufoxide reductase 1 (SelR1) Homo sapiens SPP00000022_1.0 Methionine-R-sufoxide reductase 2 (SelR2) Homo sapiens SPP00000023_1.0 Methionine-R-sufoxide reductase 3 (SelR3) Homo sapiens SPP00000024_1.0 Selenoprotein S (SelS) Homo sapiens SPP00000025_1.0 Selenoprotein T (SelT) Homo sapiens SPP00000026_1.0 Selenoprotein U1 (SelU1) Homo sapiens SPP00000027_1.0 Selenoprotein U2 (SelU2) Homo sapiens SPP00000028_1.0 Selenoprotein U3 (SelU3) Homo sapiens SPP00000029_1.0 Selenoprotein V (SelV) Homo sapiens SPP00000030_1.0 Selenoprotein W1 (SelW1) Homo sapiens SPP00000031_1.0 Selenoprotein W2 (SelW2) Homo sapiens SPP00000032_1.0 Selenophosphate synthetase 1 (SPS1) Homo sapiens SPP00000033_1.0 Selenophosphate synthetase 2 (SPS2) Homo sapiens SPP00000034_1.0 Thioredoxin reductase 1 (TR1) Homo sapiens SPP00000035_1.0 Thioredoxin reductase 2 (TR2) Homo sapiens SPP00000036_1.0 Thioredoxin reductase 3 (TR3) Homo sapiens SPP00000037_1.0 SECIS binding protein 2 (SBP2) Homo sapiens SPP00000038_1.0 Eukaryotic elongation factor (eEFSec) Homo sapiens SPP00000039_1.0 Methionine sulfoxide reductase A (MsrA) Drosophila melanogaster SPP00000040_1.0 Selenoprotein 15 (Sel15) Drosophila melanogaster SPP00000041_1.0 Selenoprotein H1 (SelH1) Drosophila melanogaster SPP00000042_1.0 Selenoprotein H2 (SelH2) Drosophila melanogaster SPP00000043_1.0 Selenoprotein H3 (SelH3) Drosophila melanogaster SPP00000044_1.0 Selenoprotein K1 (SelK1) Drosophila melanogaster SPP00000045_1.0 Selenoprotein K2 (SelK2) Drosophila melanogaster SPP00000046_1.0 Selenoprotein T (SelT) Drosophila melanogaster SPP00000047_1.0 Selenophosphate synthetase 1 (SPS1) Drosophila melanogaster SPP00000048_1.0 Selenophosphate synthetase 2 (SPS2) Drosophila melanogaster SPP00000049_1.0 Methionine sulfoxide reductase A1 (MsrA1) Anopheles gambiae SPP00000050_1.0 Methionine sulfoxide reductase A2 (MsrA2) Anopheles gambiae SPP00000051_1.0 Selenoprotein 15 (Sel15) Anopheles gambiae SPP00000052_1.0 Selenoprotein H1 (SelH1) Anopheles gambiae SPP00000053_1.0 Selenoprotein K1 (SelK1) Anopheles gambiae SPP00000054_1.0 Selenoprotein T (SelT) Anopheles gambiae SPP00000055_1.0 Selenophosphate synthetase 1 (SPS1) Anopheles gambiae SPP00000056_1.0 Selenophosphate synthetase 2 (SPS2) Anopheles gambiae SPP00000057_1.0 Selenoprotein 15 (Sel15)0000117_1.0 Selenoprotein W1